act_report

Dataset statistics

Number of variables	19
Number of observations	1892
Missing cells	5468
Missing cells (%)	15.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	282.9 KiB
Average record size in memory	153.1 B

Variable types

Numeric	9
DateTime	1
Categorical	9

Alerts

`rating_denominator` has constant value "10"	Constant
`text` has a high cardinality: 1892 distinct values	High cardinality
`expanded_urls` has a high cardinality: 1778 distinct values	High cardinality
`name` has a high cardinality: 812 distinct values	High cardinality
`t_link` has a high cardinality: 1578 distinct values	High cardinality
`id` is highly correlated with `in_reply_to_status_id` and 5 other fields	High correlation
`in_reply_to_status_id` is highly correlated with `id` and 4 other fields	High correlation
`in_reply_to_user_id` is highly correlated with `id` and 3 other fields	High correlation
`retweeted_status_id` is highly correlated with `id` and 3 other fields	High correlation
`rating_numerator` is highly correlated with `id`	High correlation
`retweet_count` is highly correlated with `id` and 2 other fields	High correlation
`month` is highly correlated with `id` and 5 other fields	High correlation
`day_of_the year` is highly correlated with `id` and 5 other fields	High correlation
`year` is highly correlated with `id` and 4 other fields	High correlation
`rating_denominator` is highly correlated with `year` and 3 other fields	High correlation
`stage` is highly correlated with `in_reply_to_status_id` and 1 other fields	High correlation
`favourites_count` is highly correlated with `rating_denominator`	High correlation
`source` is highly correlated with `rating_denominator`	High correlation
`in_reply_to_status_id` has 1833 (96.9%) missing values	Missing
`in_reply_to_user_id` has 1833 (96.9%) missing values	Missing
`retweeted_status_id` has 1722 (91.0%) missing values	Missing
`expanded_urls` has 43 (2.3%) missing values	Missing
`name` has 37 (2.0%) missing values	Missing
`text` is uniformly distributed	Uniform
`expanded_urls` is uniformly distributed	Uniform
`id` has unique values	Unique
`timestamp` has unique values	Unique
`text` has unique values	Unique
`week` has 303 (16.0%) zeros	Zeros

Reproduction

Analysis started	2022-09-14 21:06:14.604472
Analysis finished	2022-09-14 21:09:14.838806
Duration	3 minutes and 0.23 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	1892
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.549565161 × 10¹⁷

Minimum	6.660507588 × 10¹⁷
Maximum	8.924206436 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	6.660507588 × 10¹⁷
5-th percentile	6.6932792 × 10¹⁷
Q1	6.874723173 × 10¹⁷
median	7.490698138 × 10¹⁷
Q3	8.145572518 × 10¹⁷
95-th percentile	8.734468895 × 10¹⁷
Maximum	8.924206436 × 10¹⁷
Range	2.263698848 × 10¹⁷
Interquartile range (IQR)	1.270849344 × 10¹⁷

Descriptive statistics

Standard deviation	6.893761917 × 10¹⁶
Coefficient of variation (CV)	0.09131336401
Kurtosis	-1.230421654
Mean	7.549565161 × 10¹⁷
Median Absolute Deviation (MAD)	6.341984596 × 10¹⁶
Skewness	0.3106799236
Sum	7.978434787 × 10¹⁸
Variance	4.752395336 × 10³³
Monotonicity	Strictly decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.924206436 × 10¹⁷	1	0.1%
7.030419497 × 10¹⁷	1	0.1%
7.018056424 × 10¹⁷	1	0.1%
7.018891871 × 10¹⁷	1	0.1%
7.019528166 × 10¹⁷	1	0.1%
7.019813905 × 10¹⁷	1	0.1%
7.022767488 × 10¹⁷	1	0.1%
7.023211405 × 10¹⁷	1	0.1%
7.023325423 × 10¹⁷	1	0.1%
7.025395137 × 10¹⁷	1	0.1%
Other values (1882)	1882	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.660507588 × 10¹⁷	1	0.1%
6.66055525 × 10¹⁷	1	0.1%
6.660638273 × 10¹⁷	1	0.1%
6.660731008 × 10¹⁷	1	0.1%
6.661021559 × 10¹⁷	1	0.1%
6.662689108 × 10¹⁷	1	0.1%
6.662730976 × 10¹⁷	1	0.1%
6.663454176 × 10¹⁷	1	0.1%
6.663737537 × 10¹⁷	1	0.1%
6.664187895 × 10¹⁷	1	0.1%

Value	Count	Frequency (%)
8.924206436 × 10¹⁷	1	0.1%
8.921774213 × 10¹⁷	1	0.1%
8.918151814 × 10¹⁷	1	0.1%
8.916895573 × 10¹⁷	1	0.1%
8.913275589 × 10¹⁷	1	0.1%
8.910879509 × 10¹⁷	1	0.1%
8.909719132 × 10¹⁷	1	0.1%
8.907291814 × 10¹⁷	1	0.1%
8.906091852 × 10¹⁷	1	0.1%
8.902402553 × 10¹⁷	1	0.1%

in_reply_to_status_id
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	58
Distinct (%)	98.3%
Missing	1833
Missing (%)	96.9%
Infinite	0
Infinite (%)	0.0%
Mean	7.483041841 × 10¹⁷

Minimum	6.658146967 × 10¹⁷
Maximum	8.862663571 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	6.658146967 × 10¹⁷
5-th percentile	6.671521641 × 10¹⁷
Q1	6.75174596 × 10¹⁷
median	7.291135313 × 10¹⁷
Q3	8.22239491 × 10¹⁷
95-th percentile	8.716089652 × 10¹⁷
Maximum	8.862663571 × 10¹⁷
Range	2.204516604 × 10¹⁷
Interquartile range (IQR)	1.47064895 × 10¹⁷

Descriptive statistics

Standard deviation	7.666742434 × 10¹⁶
Coefficient of variation (CV)	0.102454892
Kurtosis	-1.422470611
Mean	7.483041841 × 10¹⁷
Median Absolute Deviation (MAD)	5.755252913 × 10¹⁶
Skewness	0.4408480782
Sum	4.414994686 × 10¹⁹
Variance	5.877893954 × 10³³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.671521641 × 10¹⁷	2	0.1%
6.780211157 × 10¹⁷	1	0.1%
7.291135313 × 10¹⁷	1	0.1%
7.079800659 × 10¹⁷	1	0.1%
7.032559358 × 10¹⁷	1	0.1%
7.044857446 × 10¹⁷	1	0.1%
6.753493843 × 10¹⁷	1	0.1%
6.706683835 × 10¹⁷	1	0.1%
6.936422322 × 10¹⁷	1	0.1%
6.935722159 × 10¹⁷	1	0.1%
Other values (48)	48	2.5%
(Missing)	1833	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.658146967 × 10¹⁷	1	0.1%
6.670655356 × 10¹⁷	1	0.1%
6.671521641 × 10¹⁷	2	0.1%
6.678064546 × 10¹⁷	1	0.1%
6.689207171 × 10¹⁷	1	0.1%
6.693543826 × 10¹⁷	1	0.1%
6.706683835 × 10¹⁷	1	0.1%
6.715610021 × 10¹⁷	1	0.1%
6.717299066 × 10¹⁷	1	0.1%
6.744688809 × 10¹⁷	1	0.1%

Value	Count	Frequency (%)
8.862663571 × 10¹⁷	1	0.1%
8.816070373 × 10¹⁷	1	0.1%
8.795538273 × 10¹⁷	1	0.1%
8.707262027 × 10¹⁷	1	0.1%
8.634256456 × 10¹⁷	1	0.1%
8.571566781 × 10¹⁷	1	0.1%
8.562860041 × 10¹⁷	1	0.1%
8.558181173 × 10¹⁷	1	0.1%
8.503288188 × 10¹⁷	1	0.1%
8.482121117 × 10¹⁷	1	0.1%

in_reply_to_user_id
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	27
Distinct (%)	45.8%
Missing	1833
Missing (%)	96.9%
Infinite	0
Infinite (%)	0.0%
Mean	2.662801758 × 10¹⁶

Minimum	11856342
Maximum	8.405478644 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	11856342
5-th percentile	16476451.8
Q1	325415888.5
median	4196983835
Q3	4196983835
95-th percentile	4249015199
Maximum	8.405478644 × 10¹⁷
Range	8.405478643 × 10¹⁷
Interquartile range (IQR)	3871567946

Descriptive statistics

Standard deviation	1.437385234 × 10¹⁷
Coefficient of variation (CV)	5.398018195
Kurtosis	27.4932333
Mean	2.662801758 × 10¹⁶
Median Absolute Deviation (MAD)	0
Skewness	5.329408792
Sum	1.571053037 × 10¹⁸
Variance	2.06607631 × 10³⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
4196983835	33	1.7%
11856342	1	0.1%
16374678	1	0.1%
467036706	1	0.1%
1198988510	1	0.1%
28785486	1	0.1%
2319108198	1	0.1%
358972768	1	0.1%
4717297476	1	0.1%
15846407	1	0.1%
Other values (17)	17	0.9%
(Missing)	1833	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11856342	1	0.1%
15846407	1	0.1%
16374678	1	0.1%
16487760	1	0.1%
20683724	1	0.1%
21435658	1	0.1%
21955058	1	0.1%
28785486	1	0.1%
29166305	1	0.1%
47384430	1	0.1%

Value	Count	Frequency (%)
8.405478644 × 10¹⁷	1	0.1%
7.305050142 × 10¹⁷	1	0.1%
4717297476	1	0.1%
4196983835	33	1.7%
3105440746	1	0.1%
2894131180	1	0.1%
2319108198	1	0.1%
2281181600	1	0.1%
1582853809	1	0.1%
1198988510	1	0.1%

timestamp
Date

UNIQUE

Distinct	1892
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

Minimum	2015-11-16 00:30:50+00:00
Maximum	2017-08-01 16:23:56+00:00

Histogram

Histogram with fixed size bins (bins=50)

source
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

iPhone	1778
Vine	84
Web Client	21
tweetdeck	9

Length

Max length	10
Median length	6
Mean length	5.96987315
Min length	4

Characters and Unicode

Total characters	11295
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	iPhone
2nd row	iPhone
3rd row	iPhone
4th row	iPhone
5th row	iPhone

Common Values

Value	Count	Frequency (%)
iPhone	1778	94.0%
Vine	84	4.4%
Web Client	21	1.1%
tweetdeck	9	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
iphone	1778	92.9%
vine	84	4.4%
web	21	1.1%
client	21	1.1%
tweetdeck	9	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	1931	17.1%
i	1883	16.7%
n	1883	16.7%
h	1778	15.7%
o	1778	15.7%
P	1778	15.7%
V	84	0.7%
t	39	0.3%
C	21	0.2%
l	21	0.2%
Other values (7)	99	0.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9370	83.0%
Uppercase Letter	1904	16.9%
Space Separator	21	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1931	20.6%
i	1883	20.1%
n	1883	20.1%
h	1778	19.0%
o	1778	19.0%
t	39	0.4%
l	21	0.2%
b	21	0.2%
w	9	0.1%
d	9	0.1%
Other values (2)	18	0.2%

Uppercase Letter

Value	Count	Frequency (%)
P	1778	93.4%
V	84	4.4%
C	21	1.1%
W	21	1.1%

Space Separator

Value	Count	Frequency (%)
	21	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11274	99.8%
Common	21	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1931	17.1%
i	1883	16.7%
n	1883	16.7%
h	1778	15.8%
o	1778	15.8%
P	1778	15.8%
V	84	0.7%
t	39	0.3%
C	21	0.2%
l	21	0.2%
Other values (6)	78	0.7%

Common

Value	Count	Frequency (%)
	21	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11295	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1931	17.1%
i	1883	16.7%
n	1883	16.7%
h	1778	15.7%
o	1778	15.7%
P	1778	15.7%
V	84	0.7%
t	39	0.3%
C	21	0.2%
l	21	0.2%
Other values (7)	99	0.9%

text
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	1892
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU	1
This is an East African Chalupa Seal. We only rate dogs. Please only send in dogs. Thank you... 10/10 https://t.co/iHe6liLwWR	1
Please pray for this pupper. Nothing wrong with her she just can't stop getting hit with banana peels. 11/10 https://t.co/8sdVenUAqr	1
This is Bilbo. He's not emotionally prepared to enter the water. 11/10 don't struggle Bilbo https://t.co/rH9SQgZUnQ	1
Meet Rilo. He's a Northern Curly Ticonderoga. Currently balancing on one paw even in strong wind. Acrobatic af 11/10 https://t.co/KInss2PXyX	1
Other values (1887)	1887

Length

Max length	167
Median length	142
Mean length	119.2209302
Min length	11

Characters and Unicode

Total characters	225566
Distinct characters	111
Distinct categories	14 ?
Distinct scripts	3 ?
Distinct blocks	8 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1892 ?
Unique (%)	100.0%

Sample

1st row	This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU
2nd row	This is Tilly. She's just checking pup on you. Hopes you're doing ok. If not, she's available for pats, snugs, boops, the whole bit. 13/10 https://t.co/0Xxu71qeIV
3rd row	This is Archie. He is a rare Norwegian Pouncing Corgo. Lives in the tall grass. You never know when one may strike. 12/10 https://t.co/wUnZnhtVJB
4th row	This is Darla. She commenced a snooze mid meal. 13/10 happens to the best of us https://t.co/tD36da7qLQ
5th row	This is Franklin. He would like you to stop calling him "cute." He is a very fierce shark and should be respected as such. 12/10 #BarkWeek https://t.co/AtUZn91f7f

Common Values

Value	Count	Frequency (%)
This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU	1	0.1%
This is an East African Chalupa Seal. We only rate dogs. Please only send in dogs. Thank you... 10/10 https://t.co/iHe6liLwWR	1	0.1%
Please pray for this pupper. Nothing wrong with her she just can't stop getting hit with banana peels. 11/10 https://t.co/8sdVenUAqr	1	0.1%
This is Bilbo. He's not emotionally prepared to enter the water. 11/10 don't struggle Bilbo https://t.co/rH9SQgZUnQ	1	0.1%
Meet Rilo. He's a Northern Curly Ticonderoga. Currently balancing on one paw even in strong wind. Acrobatic af 11/10 https://t.co/KInss2PXyX	1	0.1%
This is Fiji. She's a Powdered Stegafloof. Very rare. 12/10 https://t.co/fZRob6eotY	1	0.1%
"AND IIIIIIIIIIIEIIIIIIIIIIIII WILL ALWAYS LOVE YOUUUUU" 11/10 https://t.co/rSNCEiTtfI	1	0.1%
Please enjoy this picture as much as I did. 12/10 https://t.co/7u8mM99Tj5	1	0.1%
This is Rudy. He's going to be a star. 13/10 talented af (vid by @madalynrossi) https://t.co/Dph4FDGoMd	1	0.1%
This is a Wild Tuscan Poofwiggle. Careful not to startle. Rare tongue slip. One eye magical. 12/10 would def pet https://t.co/4EnShAQjv6	1	0.1%
Other values (1882)	1882	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
is	1312	3.8%
this	1289	3.8%
a	946	2.8%
to	625	1.8%
the	621	1.8%
12/10	557	1.6%
he	540	1.6%
11/10	462	1.3%
10/10	457	1.3%
he's	455	1.3%
Other values (6975)	27002	78.8%

Most occurring characters

Value	Count	Frequency (%)
	32312	14.3%
e	15276	6.8%
t	15164	6.7%
s	12321	5.5%
o	12064	5.3%
a	9827	4.4%
i	9538	4.2%
h	8669	3.8%
/	7443	3.3%
n	7268	3.2%
Other values (101)	95684	42.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	146082	64.8%
Space Separator	32312	14.3%
Other Punctuation	18398	8.2%
Uppercase Letter	17367	7.7%
Decimal Number	10692	4.7%
Connector Punctuation	199	0.1%
Control	151	0.1%
Close Punctuation	122	0.1%
Open Punctuation	122	0.1%
Dash Punctuation	74	< 0.1%
Other values (4)	47	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	15276	10.5%
t	15164	10.4%
s	12321	8.4%
o	12064	8.3%
a	9827	6.7%
i	9538	6.5%
h	8669	5.9%
n	7268	5.0%
r	7214	4.9%
l	6432	4.4%
Other values (23)	42309	29.0%

Uppercase Letter

Value	Count	Frequency (%)
T	2045	11.8%
H	1587	9.1%
S	1172	6.7%
I	846	4.9%
A	766	4.4%
M	752	4.3%
R	736	4.2%
B	696	4.0%
C	693	4.0%
P	656	3.8%
Other values (16)	7418	42.7%

Other Symbol

Value	Count	Frequency (%)
🐶	10	26.3%
🎶	6	15.8%
😂	3	7.9%
👏	3	7.9%
🇸	2	5.3%
🇺	2	5.3%
😢	1	2.6%
❤	1	2.6%
🍻	1	2.6%
🎉	1	2.6%
Other values (8)	8	21.1%

Other Punctuation

Value	Count	Frequency (%)
/	7443	40.5%
.	6578	35.8%
:	2056	11.2%
'	1296	7.0%
@	277	1.5%
*	197	1.1%
,	169	0.9%
"	140	0.8%
…	76	0.4%
;	44	0.2%
Other values (5)	122	0.7%

Decimal Number

Value	Count	Frequency (%)
1	4592	42.9%
0	2703	25.3%
2	854	8.0%
3	634	5.9%
4	362	3.4%
7	329	3.1%
6	325	3.0%
5	315	2.9%
8	289	2.7%
9	289	2.7%

Space Separator

Value	Count	Frequency (%)
	32312	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	199	100.0%

Control

Value	Count	Frequency (%)
	151	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	122	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	122	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	74	100.0%

Math Symbol

Value	Count	Frequency (%)
=	4	100.0%

Modifier Symbol

Value	Count	Frequency (%)
🏻	3	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
️	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	163449	72.5%
Common	62115	27.5%
Inherited	2	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	15276	9.3%
t	15164	9.3%
s	12321	7.5%
o	12064	7.4%
a	9827	6.0%
i	9538	5.8%
h	8669	5.3%
n	7268	4.4%
r	7214	4.4%
l	6432	3.9%
Other values (49)	59676	36.5%

Common

Value	Count	Frequency (%)
	32312	52.0%
/	7443	12.0%
.	6578	10.6%
1	4592	7.4%
0	2703	4.4%
:	2056	3.3%
'	1296	2.1%
2	854	1.4%
3	634	1.0%
4	362	0.6%
Other values (41)	3285	5.3%

Inherited

Value	Count	Frequency (%)
️	2	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	225436	99.9%
Punctuation	76	< 0.1%
None	40	< 0.1%
Emoticons	5	< 0.1%
Enclosed Alphanum Sup	4	< 0.1%
VS	2	< 0.1%
Misc Symbols	2	< 0.1%
Dingbats	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	32312	14.3%
e	15276	6.8%
t	15164	6.7%
s	12321	5.5%
o	12064	5.4%
a	9827	4.4%
i	9538	4.2%
h	8669	3.8%
/	7443	3.3%
n	7268	3.2%
Other values (73)	95554	42.4%

Punctuation

Value	Count	Frequency (%)
…	76	100.0%

None

Value	Count	Frequency (%)
🐶	10	25.0%
🎶	6	15.0%
é	4	10.0%
👏	3	7.5%
🏻	3	7.5%
á	2	5.0%
ó	1	2.5%
ñ	1	2.5%
ä	1	2.5%
🍻	1	2.5%
Other values (8)	8	20.0%

Emoticons

Value	Count	Frequency (%)
😂	3	60.0%
😢	1	20.0%
😉	1	20.0%

Enclosed Alphanum Sup

Value	Count	Frequency (%)
🇸	2	50.0%
🇺	2	50.0%

VS

Value	Count	Frequency (%)
️	2	100.0%

Dingbats

Value	Count	Frequency (%)
❤	1	100.0%

Misc Symbols

Value	Count	Frequency (%)
⚽	1	50.0%
☘	1	50.0%

retweeted_status_id
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	170
Distinct (%)	100.0%
Missing	1722
Missing (%)	91.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.749665736 × 10¹⁷

Minimum	6.671382697 × 10¹⁷
Maximum	8.860537344 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	6.671382697 × 10¹⁷
5-th percentile	6.710982898 × 10¹⁷
Q1	7.33930252 × 10¹⁷
median	7.825142333 × 10¹⁷
Q3	8.218710416 × 10¹⁷
95-th percentile	8.663986222 × 10¹⁷
Maximum	8.860537344 × 10¹⁷
Range	2.189154647 × 10¹⁷
Interquartile range (IQR)	8.794078964 × 10¹⁶

Descriptive statistics

Standard deviation	6.111924085 × 10¹⁶
Coefficient of variation (CV)	0.07886693818
Kurtosis	-0.9451326486
Mean	7.749665736 × 10¹⁷
Median Absolute Deviation (MAD)	4.312311472 × 10¹⁶
Skewness	-0.2702657982
Sum	1.317443175 × 10²⁰
Variance	3.735561602 × 10³³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.961497491 × 10¹⁷	1	0.1%
6.75501076 × 10¹⁷	1	0.1%
6.718968093 × 10¹⁷	1	0.1%
6.704449557 × 10¹⁷	1	0.1%
6.67509364 × 10¹⁷	1	0.1%
6.671827921 × 10¹⁷	1	0.1%
7.717704565 × 10¹⁷	1	0.1%
6.873173063 × 10¹⁷	1	0.1%
7.809316142 × 10¹⁷	1	0.1%
7.89530877 × 10¹⁷	1	0.1%
Other values (160)	160	8.5%
(Missing)	1722	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.671382697 × 10¹⁷	1	0.1%
6.671521641 × 10¹⁷	1	0.1%
6.671827921 × 10¹⁷	1	0.1%
6.67509364 × 10¹⁷	1	0.1%
6.675486957 × 10¹⁷	1	0.1%
6.678667243 × 10¹⁷	1	0.1%
6.690003974 × 10¹⁷	1	0.1%
6.703191306 × 10¹⁷	1	0.1%
6.704449557 × 10¹⁷	1	0.1%
6.718968093 × 10¹⁷	1	0.1%

Value	Count	Frequency (%)
8.860537344 × 10¹⁷	1	0.1%
8.78281511 × 10¹⁷	1	0.1%
8.78057613 × 10¹⁷	1	0.1%
8.768507723 × 10¹⁷	1	0.1%
8.732137756 × 10¹⁷	1	0.1%
8.726575843 × 10¹⁷	1	0.1%
8.688803978 × 10¹⁷	1	0.1%
8.685522785 × 10¹⁷	1	0.1%
8.664507055 × 10¹⁷	1	0.1%
8.663349648 × 10¹⁷	1	0.1%

expanded_urls
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	1778
Distinct (%)	96.2%
Missing	43
Missing (%)	2.3%
Memory size	29.6 KiB

https://twitter.com/dog_rates/status/819227688460238848/photo/1	2
https://www.gofundme.com/my-puppys-double-cataract-surgery,https://twitter.com/dog_rates/status/825026590719483904/photo/1,https://twitter.com/dog_rates/status/825026590719483904/photo/1	2
https://www.gofundme.com/help-lorenzo-beat-cancer,https://twitter.com/dog_rates/status/860563773140209665/photo/1,https://twitter.com/dog_rates/status/860563773140209665/photo/1	2
https://twitter.com/dog_rates/status/762464539388485633/photo/1,https://twitter.com/dog_rates/status/762464539388485633/photo/1,https://twitter.com/dog_rates/status/762464539388485633/photo/1,https://twitter.com/dog_rates/status/762464539388485633/photo/1	2
https://twitter.com/dog_rates/status/762699858130116608/photo/1	2
Other values (1773)	1839

Length

Max length	511
Median length	63
Mean length	96.95457004
Min length	29

Characters and Unicode

Total characters	179269
Distinct characters	72
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1707 ?
Unique (%)	92.3%

Sample

1st row	https://twitter.com/dog_rates/status/892420643555336193/photo/1
2nd row	https://twitter.com/dog_rates/status/892177421306343426/photo/1
3rd row	https://twitter.com/dog_rates/status/891815181378084864/photo/1
4th row	https://twitter.com/dog_rates/status/891689557279858688/photo/1
5th row	https://twitter.com/dog_rates/status/891327558926688256/photo/1,https://twitter.com/dog_rates/status/891327558926688256/photo/1

Common Values

Value	Count	Frequency (%)
https://twitter.com/dog_rates/status/819227688460238848/photo/1	2	0.1%
https://www.gofundme.com/my-puppys-double-cataract-surgery,https://twitter.com/dog_rates/status/825026590719483904/photo/1,https://twitter.com/dog_rates/status/825026590719483904/photo/1	2	0.1%
https://www.gofundme.com/help-lorenzo-beat-cancer,https://twitter.com/dog_rates/status/860563773140209665/photo/1,https://twitter.com/dog_rates/status/860563773140209665/photo/1	2	0.1%
https://twitter.com/dog_rates/status/762464539388485633/photo/1,https://twitter.com/dog_rates/status/762464539388485633/photo/1,https://twitter.com/dog_rates/status/762464539388485633/photo/1,https://twitter.com/dog_rates/status/762464539388485633/photo/1	2	0.1%
https://twitter.com/dog_rates/status/762699858130116608/photo/1	2	0.1%
https://www.gofundme.com/helpquinny,https://twitter.com/dog_rates/status/863062471531167744/photo/1,https://twitter.com/dog_rates/status/863062471531167744/photo/1,https://twitter.com/dog_rates/status/863062471531167744/photo/1,https://twitter.com/dog_rates/status/863062471531167744/photo/1	2	0.1%
https://twitter.com/dog_rates/status/820749716845686786/photo/1,https://twitter.com/dog_rates/status/820749716845686786/photo/1	2	0.1%
https://vine.co/v/ea0OwvPTx9l	2	0.1%
https://twitter.com/dog_rates/status/837820167694528512/photo/1,https://twitter.com/dog_rates/status/837820167694528512/photo/1	2	0.1%
https://twitter.com/dog_rates/status/786233965241827333/photo/1	2	0.1%
Other values (1768)	1829	96.7%
(Missing)	43	2.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://twitter.com/dog_rates/status/819227688460238848/photo/1	2	0.1%
https://www.gofundme.com/lolas-life-saving-surgery-funds,https://twitter.com/dog_rates/status/835264098648616962/photo/1,https://twitter.com/dog_rates/status/835264098648616962/photo/1	2	0.1%
https://twitter.com/dog_rates/status/842163532590374912/photo/1,https://twitter.com/dog_rates/status/842163532590374912/photo/1	2	0.1%
https://twitter.com/dog_rates/status/810254108431155201/photo/1	2	0.1%
http://www.gofundme.com/bluethewhitehusky,https://twitter.com/dog_rates/status/831650051525054464/photo/1,https://twitter.com/dog_rates/status/831650051525054464/photo/1,https://twitter.com/dog_rates/status/831650051525054464/photo/1,https://twitter.com/dog_rates/status/831650051525054464/photo/1	2	0.1%
https://twitter.com/dog_rates/status/809220051211603969/photo/1,https://twitter.com/dog_rates/status/809220051211603969/photo/1	2	0.1%
https://twitter.com/dog_rates/status/759923798737051648/photo/1	2	0.1%
https://twitter.com/dog_rates/status/739979191639244800/photo/1	2	0.1%
https://twitter.com/dog_rates/status/833124694597443584/photo/1,https://twitter.com/dog_rates/status/833124694597443584/photo/1,https://twitter.com/dog_rates/status/833124694597443584/photo/1	2	0.1%
https://twitter.com/dog_rates/status/700143752053182464/photo/1	2	0.1%
Other values (1768)	1829	98.9%

Most occurring characters

Value	Count	Frequency (%)
t	24927	13.9%
/	19714	11.0%
s	11166	6.2%
o	11035	6.2%
1	7108	4.0%
8	6165	3.4%
e	5852	3.3%
7	5734	3.2%
h	5615	3.1%
a	5602	3.1%
Other values (62)	76351	42.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	96852	54.0%
Decimal Number	52417	29.2%
Other Punctuation	26615	14.8%
Connector Punctuation	2684	1.5%
Uppercase Letter	605	0.3%
Dash Punctuation	87	< 0.1%
Math Symbol	9	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	24927	25.7%
s	11166	11.5%
o	11035	11.4%
e	5852	6.0%
h	5615	5.8%
a	5602	5.8%
p	5602	5.8%
r	5565	5.7%
i	3115	3.2%
c	2959	3.1%
Other values (16)	15414	15.9%

Uppercase Letter

Value	Count	Frequency (%)
E	38	6.3%
M	38	6.3%
X	35	5.8%
O	33	5.5%
F	33	5.5%
Y	33	5.5%
K	32	5.3%
L	31	5.1%
D	30	5.0%
W	30	5.0%
Other values (16)	272	45.0%

Decimal Number

Value	Count	Frequency (%)
1	7108	13.6%
8	6165	11.8%
7	5734	10.9%
6	5567	10.6%
0	5262	10.0%
4	4577	8.7%
2	4539	8.7%
3	4494	8.6%
5	4492	8.6%
9	4479	8.5%

Other Punctuation

Value	Count	Frequency (%)
/	19714	74.1%
.	2944	11.1%
:	2896	10.9%
,	1047	3.9%
?	6	< 0.1%
&	4	< 0.1%
%	4	< 0.1%

Connector Punctuation

Value	Count	Frequency (%)
_	2684	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	87	100.0%

Math Symbol

Value	Count	Frequency (%)
=	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	97457	54.4%
Common	81812	45.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	24927	25.6%
s	11166	11.5%
o	11035	11.3%
e	5852	6.0%
h	5615	5.8%
a	5602	5.7%
p	5602	5.7%
r	5565	5.7%
i	3115	3.2%
c	2959	3.0%
Other values (42)	16019	16.4%

Common

Value	Count	Frequency (%)
/	19714	24.1%
1	7108	8.7%
8	6165	7.5%
7	5734	7.0%
6	5567	6.8%
0	5262	6.4%
4	4577	5.6%
2	4539	5.5%
3	4494	5.5%
5	4492	5.5%
Other values (10)	14160	17.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	179269	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	24927	13.9%
/	19714	11.0%
s	11166	6.2%
o	11035	6.2%
1	7108	4.0%
8	6165	3.4%
e	5852	3.3%
7	5734	3.2%
h	5615	3.1%
a	5602	3.1%
Other values (62)	76351	42.6%

rating_numerator
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.59778013

Minimum	10
Maximum	75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	10
5-th percentile	10
Q1	11
median	12
Q3	12
95-th percentile	13
Maximum	75
Range	65
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.408440854
Coefficient of variation (CV)	0.2076639519
Kurtosis	508.2309534
Mean	11.59778013
Median Absolute Deviation (MAD)	1
Skewness	19.56729611
Sum	21943
Variance	5.800587349
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	557	29.4%
11	463	24.5%
10	461	24.4%
13	350	18.5%
14	54	2.9%
15	2	0.1%
75	2	0.1%
17	1	0.1%
27	1	0.1%
26	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	461	24.4%
11	463	24.5%
12	557	29.4%
13	350	18.5%
14	54	2.9%
15	2	0.1%
17	1	0.1%
26	1	0.1%
27	1	0.1%
75	2	0.1%

Value	Count	Frequency (%)
75	2	0.1%
27	1	0.1%
26	1	0.1%
17	1	0.1%
15	2	0.1%
14	54	2.9%
13	350	18.5%
12	557	29.4%
11	463	24.5%
10	461	24.4%

rating_denominator
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

10	1892

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3784
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10
2nd row	10
3rd row	10
4th row	10
5th row	10

Common Values

Value	Count	Frequency (%)
10	1892	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
10	1892	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	1892	50.0%
0	1892	50.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3784	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1892	50.0%
0	1892	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3784	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1892	50.0%
0	1892	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3784	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1892	50.0%
0	1892	50.0%

name
Categorical

HIGH CARDINALITY
MISSING

Distinct	812
Distinct (%)	43.8%
Missing	37
Missing (%)	2.0%
Memory size	29.6 KiB

None	583
Charlie	12
Cooper	10
Lucy	10
Oliver	10
Other values (807)	1230

Length

Max length	14
Median length	11
Mean length	4.939083558
Min length	1

Characters and Unicode

Total characters	9162
Distinct characters	55
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	575 ?
Unique (%)	31.0%

Sample

1st row	Phineas
2nd row	Tilly
3rd row	Archie
4th row	Darla
5th row	Franklin

Common Values

Value	Count	Frequency (%)
None	583	30.8%
Charlie	12	0.6%
Cooper	10	0.5%
Lucy	10	0.5%
Oliver	10	0.5%
Tucker	9	0.5%
Bo	9	0.5%
Lola	8	0.4%
Winston	8	0.4%
Penny	8	0.4%
Other values (802)	1188	62.8%
(Missing)	37	2.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	583	31.4%
charlie	12	0.6%
cooper	10	0.5%
lucy	10	0.5%
oliver	10	0.5%
tucker	9	0.5%
bo	9	0.5%
lola	8	0.4%
winston	8	0.4%
penny	8	0.4%
Other values (802)	1188	64.0%

Most occurring characters

Value	Count	Frequency (%)
e	1336	14.6%
o	1059	11.6%
n	960	10.5%
N	602	6.6%
a	538	5.9%
i	472	5.2%
l	414	4.5%
r	404	4.4%
y	275	3.0%
s	243	2.7%
Other values (45)	2859	31.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7334	80.0%
Uppercase Letter	1828	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1336	18.2%
o	1059	14.4%
n	960	13.1%
a	538	7.3%
i	472	6.4%
l	414	5.6%
r	404	5.5%
y	275	3.7%
s	243	3.3%
u	234	3.2%
Other values (20)	1399	19.1%

Uppercase Letter

Value	Count	Frequency (%)
N	602	32.9%
S	129	7.1%
B	119	6.5%
C	114	6.2%
L	95	5.2%
R	85	4.6%
M	82	4.5%
T	64	3.5%
D	63	3.4%
A	60	3.3%
Other values (15)	415	22.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9162	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1336	14.6%
o	1059	11.6%
n	960	10.5%
N	602	6.6%
a	538	5.9%
i	472	5.2%
l	414	4.5%
r	404	4.4%
y	275	3.0%
s	243	2.7%
Other values (45)	2859	31.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9154	99.9%
None	8	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1336	14.6%
o	1059	11.6%
n	960	10.5%
N	602	6.6%
a	538	5.9%
i	472	5.2%
l	414	4.5%
r	404	4.4%
y	275	3.0%
s	243	2.7%
Other values (41)	2851	31.1%

None

Value	Count	Frequency (%)
é	4	50.0%
á	2	25.0%
ò	1	12.5%
ó	1	12.5%

stage
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	16.8 KiB

None	1561
pupper	213
doggo	79
puppo	29
floofer	10

Length

Max length	7
Median length	4
Mean length	4.298097252
Min length	4

Characters and Unicode

Total characters	8132
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	1561	82.5%
pupper	213	11.3%
doggo	79	4.2%
puppo	29	1.5%
floofer	10	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
none	1561	82.5%
pupper	213	11.3%
doggo	79	4.2%
puppo	29	1.5%
floofer	10	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	1784	21.9%
o	1768	21.7%
N	1561	19.2%
n	1561	19.2%
p	726	8.9%
u	242	3.0%
r	223	2.7%
g	158	1.9%
d	79	1.0%
f	20	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6571	80.8%
Uppercase Letter	1561	19.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1784	27.1%
o	1768	26.9%
n	1561	23.8%
p	726	11.0%
u	242	3.7%
r	223	3.4%
g	158	2.4%
d	79	1.2%
f	20	0.3%
l	10	0.2%

Uppercase Letter

Value	Count	Frequency (%)
N	1561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8132	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1784	21.9%
o	1768	21.7%
N	1561	19.2%
n	1561	19.2%
p	726	8.9%
u	242	3.0%
r	223	2.7%
g	158	1.9%
d	79	1.0%
f	20	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8132	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1784	21.9%
o	1768	21.7%
N	1561	19.2%
n	1561	19.2%
p	726	8.9%
u	242	3.0%
r	223	2.7%
g	158	1.9%
d	79	1.0%
f	20	0.2%

favourites_count
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

114031	1877
114032	15

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	11352
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	114031
2nd row	114031
3rd row	114031
4th row	114031
5th row	114031

Common Values

Value	Count	Frequency (%)
114031	1877	99.2%
114032	15	0.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
114031	1877	99.2%
114032	15	0.8%

Most occurring characters

Value	Count	Frequency (%)
1	5661	49.9%
4	1892	16.7%
0	1892	16.7%
3	1892	16.7%
2	15	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11352	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5661	49.9%
4	1892	16.7%
0	1892	16.7%
3	1892	16.7%
2	15	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	11352	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	5661	49.9%
4	1892	16.7%
0	1892	16.7%
3	1892	16.7%
2	15	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11352	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	5661	49.9%
4	1892	16.7%
0	1892	16.7%
3	1892	16.7%
2	15	0.1%

retweet_count
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1484
Distinct (%)	78.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3667.895349

Minimum	0
Maximum	79515
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	0
5-th percentile	141.1
Q1	771.75
median	1923
Q3	4194.25
95-th percentile	12165.7
Maximum	79515
Range	79515
Interquartile range (IQR)	3422.5

Descriptive statistics

Standard deviation	5739.243632
Coefficient of variation (CV)	1.564723932
Kurtosis	38.50815817
Mean	3667.895349
Median Absolute Deviation (MAD)	1373
Skewness	5.025032153
Sum	6939658
Variance	32938917.47
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1972	5	0.3%
3652	5	0.3%
83	4	0.2%
577	4	0.2%
115	4	0.2%
1207	4	0.2%
3261	3	0.2%
748	3	0.2%
1231	3	0.2%
179	3	0.2%
Other values (1474)	1854	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
2	1	0.1%
3	2	0.1%
4	1	0.1%
6	1	0.1%
7	1	0.1%
10	2	0.1%
14	1	0.1%
16	1	0.1%
17	1	0.1%

Value	Count	Frequency (%)
79515	1	0.1%
56625	2	0.1%
52360	2	0.1%
48265	1	0.1%
45849	1	0.1%
42228	2	0.1%
37911	2	0.1%
33421	2	0.1%
32883	2	0.1%
31989	1	0.1%

t_link
Categorical

HIGH CARDINALITY

Distinct	1578
Distinct (%)	83.4%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

NaN	250
https://t.co/zrMVdfFej6	2
https://t.co/Bb3xnpsWBC	2
https://t.co/y5KarNXWXt	2
https://t.co/liJGwMp17E	2
Other values (1573)	1634

Length

Max length	23
Median length	23
Mean length	20.35729387
Min length	3

Characters and Unicode

Total characters	38516
Distinct characters	65
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1512 ?
Unique (%)	79.9%

Sample

1st row	https://t.co/MgUWQ76dJU
2nd row	https://t.co/0Xxu71qeIV
3rd row	https://t.co/wUnZnhtVJB
4th row	https://t.co/tD36da7qLQ
5th row	https://t.co/AtUZn91f7f

Common Values

Value	Count	Frequency (%)
NaN	250	13.2%
https://t.co/zrMVdfFej6	2	0.1%
https://t.co/Bb3xnpsWBC	2	0.1%
https://t.co/y5KarNXWXt	2	0.1%
https://t.co/liJGwMp17E	2	0.1%
https://t.co/ghyT4Ubk1r	2	0.1%
https://t.co/QV5nx6otZR	2	0.1%
https://t.co/Ln89R4FP7v	2	0.1%
https://t.co/lprdOylVpS	2	0.1%
https://t.co/rLi83ZyCL5	2	0.1%
Other values (1568)	1624	85.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	250	13.2%
https://t.co/o5j479bzuc	2	0.1%
https://t.co/mimktsln6k	2	0.1%
https://t.co/tu4szogviq	2	0.1%
https://t.co/mh0ioyfdig	2	0.1%
https://t.co/hyac5hq9gc	2	0.1%
https://t.co/jkxh0nbbnl	2	0.1%
https://t.co/suxci9b7pq	2	0.1%
https://t.co/r6wjyc2tey	2	0.1%
https://t.co/dkbyacag2d	2	0.1%
Other values (1568)	1624	85.8%

Most occurring characters

Value	Count	Frequency (%)
t	5164	13.4%
/	4926	12.8%
c	1897	4.9%
o	1897	4.9%
p	1893	4.9%
h	1885	4.9%
s	1878	4.9%
:	1642	4.3%
.	1642	4.3%
N	772	2.0%
Other values (55)	14920	38.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20124	52.2%
Other Punctuation	8210	21.3%
Uppercase Letter	7574	19.7%
Decimal Number	2608	6.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	5164	25.7%
c	1897	9.4%
o	1897	9.4%
p	1893	9.4%
h	1885	9.4%
s	1878	9.3%
a	510	2.5%
d	301	1.5%
u	301	1.5%
r	299	1.5%
Other values (16)	4099	20.4%

Uppercase Letter

Value	Count	Frequency (%)
N	772	10.2%
A	311	4.1%
I	311	4.1%
X	300	4.0%
H	290	3.8%
B	289	3.8%
Q	283	3.7%
E	282	3.7%
C	279	3.7%
J	278	3.7%
Other values (16)	4179	55.2%

Decimal Number

Value	Count	Frequency (%)
6	282	10.8%
7	280	10.7%
5	272	10.4%
0	272	10.4%
1	256	9.8%
4	256	9.8%
9	255	9.8%
8	254	9.7%
3	243	9.3%
2	238	9.1%

Other Punctuation

Value	Count	Frequency (%)
/	4926	60.0%
:	1642	20.0%
.	1642	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27698	71.9%
Common	10818	28.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	5164	18.6%
c	1897	6.8%
o	1897	6.8%
p	1893	6.8%
h	1885	6.8%
s	1878	6.8%
N	772	2.8%
a	510	1.8%
A	311	1.1%
I	311	1.1%
Other values (42)	11180	40.4%

Common

Value	Count	Frequency (%)
/	4926	45.5%
:	1642	15.2%
.	1642	15.2%
6	282	2.6%
7	280	2.6%
5	272	2.5%
0	272	2.5%
1	256	2.4%
4	256	2.4%
9	255	2.4%
Other values (3)	735	6.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38516	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	5164	13.4%
/	4926	12.8%
c	1897	4.9%
o	1897	4.9%
p	1893	4.9%
h	1885	4.9%
s	1878	4.9%
:	1642	4.3%
.	1642	4.3%
N	772	2.0%
Other values (55)	14920	38.7%

month
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.67230444

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	7
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.990657304
Coefficient of variation (CV)	0.5980928089
Kurtosis	-1.497672987
Mean	6.67230444
Median Absolute Deviation (MAD)	4
Skewness	-0.0007991162542
Sum	12624
Variance	15.92534572
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	314	16.6%
11	251	13.3%
1	235	12.4%
3	179	9.5%
2	176	9.3%
7	146	7.7%
6	137	7.2%
4	109	5.8%
5	108	5.7%
10	88	4.7%
Other values (2)	149	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	235	12.4%
2	176	9.3%
3	179	9.5%
4	109	5.8%
5	108	5.7%
6	137	7.2%
7	146	7.7%
8	70	3.7%
9	79	4.2%
10	88	4.7%

Value	Count	Frequency (%)
12	314	16.6%
11	251	13.3%
10	88	4.7%
9	79	4.2%
8	70	3.7%
7	146	7.7%
6	137	7.2%
5	108	5.7%
4	109	5.8%
3	179	9.5%

week
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.839852008

Minimum	0
Maximum	6
Zeros	303
Zeros (%)	16.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.983868732
Coefficient of variation (CV)	0.698581731
Kurtosis	-1.229808596
Mean	2.839852008
Median Absolute Deviation (MAD)	2
Skewness	0.08532368946
Sum	5373
Variance	3.935735145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	303	16.0%
1	288	15.2%
2	279	14.7%
4	270	14.3%
3	270	14.3%
5	255	13.5%
6	227	12.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	303	16.0%
1	288	15.2%
2	279	14.7%
3	270	14.3%
4	270	14.3%
5	255	13.5%
6	227	12.0%

Value	Count	Frequency (%)
6	227	12.0%
5	255	13.5%
4	270	14.3%
3	270	14.3%
2	279	14.7%
1	288	15.2%
0	303	16.0%

day_of_the year
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	362
Distinct (%)	19.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	188.096723

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	29.6 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	70
median	183
Q3	324
95-th percentile	354
Maximum	366
Range	365
Interquartile range (IQR)	254

Descriptive statistics

Standard deviation	122.4755478
Coefficient of variation (CV)	0.6511306833
Kurtosis	-1.505204987
Mean	188.096723
Median Absolute Deviation (MAD)	126
Skewness	0.002206727895
Sum	355879
Variance	15000.25981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
327	20	1.1%
341	18	1.0%
342	18	1.0%
332	18	1.0%
344	18	1.0%
346	16	0.8%
323	16	0.8%
326	16	0.8%
333	16	0.8%
335	16	0.8%
Other values (352)	1720	90.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	0.2%
2	10	0.5%
3	7	0.4%
4	8	0.4%
5	9	0.5%
6	9	0.5%
7	9	0.5%
8	8	0.4%
9	7	0.4%
10	7	0.4%

Value	Count	Frequency (%)
366	1	0.1%
365	5	0.3%
364	6	0.3%
363	7	0.4%
362	7	0.4%
361	9	0.5%
360	11	0.6%
359	13	0.7%
358	11	0.6%
357	5	0.3%

year
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	29.6 KiB

2016	1010
2017	471
2015	411

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	7568
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2017
3rd row	2017
4th row	2017
5th row	2017

Common Values

Value	Count	Frequency (%)
2016	1010	53.4%
2017	471	24.9%
2015	411	21.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2016	1010	53.4%
2017	471	24.9%
2015	411	21.7%

Most occurring characters

Value	Count	Frequency (%)
2	1892	25.0%
0	1892	25.0%
1	1892	25.0%
6	1010	13.3%
7	471	6.2%
5	411	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7568	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1892	25.0%
0	1892	25.0%
1	1892	25.0%
6	1010	13.3%
7	471	6.2%
5	411	5.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	7568	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1892	25.0%
0	1892	25.0%
1	1892	25.0%
6	1010	13.3%
7	471	6.2%
5	411	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7568	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1892	25.0%
0	1892	25.0%
1	1892	25.0%
6	1010	13.3%
7	471	6.2%
5	411	5.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	in_reply_to_status_id	in_reply_to_user_id	timestamp	source	text	retweeted_status_id	expanded_urls	rating_numerator	rating_denominator	name	stage	favourites_count	retweet_count	t_link	month	week	day_of_the year	year
0	892420643555336193	NaN	NaN	2017-08-01 16:23:56+00:00	iPhone	This is Phineas. He's a mystical boy. Only ever appears in the hole of a donut. 13/10 https://t.co/MgUWQ76dJU	NaN	https://twitter.com/dog_rates/status/892420643555336193/photo/1	13	10	Phineas	None	114031	8853	https://t.co/MgUWQ76dJU	8	1	213	2017
1	892177421306343426	NaN	NaN	2017-08-01 00:17:27+00:00	iPhone	This is Tilly. She's just checking pup on you. Hopes you're doing ok. If not, she's available for pats, snugs, boops, the whole bit. 13/10 https://t.co/0Xxu71qeIV	NaN	https://twitter.com/dog_rates/status/892177421306343426/photo/1	13	10	Tilly	None	114031	6514	https://t.co/0Xxu71qeIV	8	1	213	2017
2	891815181378084864	NaN	NaN	2017-07-31 00:18:03+00:00	iPhone	This is Archie. He is a rare Norwegian Pouncing Corgo. Lives in the tall grass. You never know when one may strike. 12/10 https://t.co/wUnZnhtVJB	NaN	https://twitter.com/dog_rates/status/891815181378084864/photo/1	12	10	Archie	None	114031	4328	https://t.co/wUnZnhtVJB	7	0	212	2017
3	891689557279858688	NaN	NaN	2017-07-30 15:58:51+00:00	iPhone	This is Darla. She commenced a snooze mid meal. 13/10 happens to the best of us https://t.co/tD36da7qLQ	NaN	https://twitter.com/dog_rates/status/891689557279858688/photo/1	13	10	Darla	None	114031	8964	https://t.co/tD36da7qLQ	7	6	211	2017
4	891327558926688256	NaN	NaN	2017-07-29 16:00:24+00:00	iPhone	This is Franklin. He would like you to stop calling him "cute." He is a very fierce shark and should be respected as such. 12/10 #BarkWeek https://t.co/AtUZn91f7f	NaN	https://twitter.com/dog_rates/status/891327558926688256/photo/1,https://twitter.com/dog_rates/status/891327558926688256/photo/1	12	10	Franklin	None	114031	9774	https://t.co/AtUZn91f7f	7	5	210	2017
5	891087950875897856	NaN	NaN	2017-07-29 00:08:17+00:00	iPhone	Here we have a majestic great white breaching off South Africa's coast. Absolutely h*ckin breathtaking. 13/10 (IG: tucker_marlo) #BarkWeek https://t.co/kQ04fDDRmh	NaN	https://twitter.com/dog_rates/status/891087950875897856/photo/1	13	10	None	None	114031	3261	https://t.co/kQ04fDDRmh	7	5	210	2017
6	890971913173991426	NaN	NaN	2017-07-28 16:27:12+00:00	iPhone	Meet Jax. He enjoys ice cream so much he gets nervous around it. 13/10 help Jax enjoy more things by clicking below\n\nhttps://t.co/Zr4hWfAs1H https://t.co/tVJBRMnhxl	NaN	https://gofundme.com/ydvmve-surgery-for-jax,https://twitter.com/dog_rates/status/890971913173991426/photo/1	13	10	Jax	None	114031	2158	https://t.co/tVJBRMnhxl	7	4	209	2017
7	890729181411237888	NaN	NaN	2017-07-28 00:22:40+00:00	iPhone	When you watch your owner call another dog a good boy but then they turn back to you and say you're a great boy. 13/10 https://t.co/v0nONBcwxq	NaN	https://twitter.com/dog_rates/status/890729181411237888/photo/1,https://twitter.com/dog_rates/status/890729181411237888/photo/1	13	10	None	None	114031	16716	https://t.co/v0nONBcwxq	7	4	209	2017
8	890609185150312448	NaN	NaN	2017-07-27 16:25:51+00:00	iPhone	This is Zoey. She doesn't want to be one of the scary sharks. Just wants to be a snuggly pettable boatpet. 13/10 #BarkWeek https://t.co/9TwLuAGH0b	NaN	https://twitter.com/dog_rates/status/890609185150312448/photo/1	13	10	Zoey	None	114031	4429	https://t.co/9TwLuAGH0b	7	3	208	2017
9	890240255349198849	NaN	NaN	2017-07-26 15:59:51+00:00	iPhone	This is Cassie. She is a college pup. Studying international doggo communication and stick theory. 14/10 so elegant much sophisticate https://t.co/t1bfwz5S2A	NaN	https://twitter.com/dog_rates/status/890240255349198849/photo/1	14	10	Cassie	doggo	114031	7711	https://t.co/t1bfwz5S2A	7	2	207	2017

Last rows

	id	in_reply_to_status_id	in_reply_to_user_id	timestamp	source	text	retweeted_status_id	expanded_urls	rating_numerator	rating_denominator	name	stage	favourites_count	retweet_count	t_link	month	week	day_of_the year	year
1882	666418789513326592	NaN	NaN	2015-11-17 00:53:15+00:00	iPhone	This is Walter. He is an Alaskan Terrapin. Loves outdated bandanas. One ear still working. Cool house plant. 10/10 https://t.co/qXpcwENTvn	NaN	https://twitter.com/dog_rates/status/666418789513326592/photo/1	10	10	Walter	None	114031	48	https://t.co/qXpcwENTvn	11	1	321	2015
1883	666373753744588802	NaN	NaN	2015-11-16 21:54:18+00:00	iPhone	Those are sunglasses and a jean jacket. 11/10 dog cool af https://t.co/uHXrPkUEyl	NaN	https://twitter.com/dog_rates/status/666373753744588802/photo/1	11	10	None	None	114031	100	https://t.co/uHXrPkUEyl	11	0	320	2015
1884	666345417576210432	NaN	NaN	2015-11-16 20:01:42+00:00	iPhone	Look at this jokester thinking seat belt laws don't apply to him. Great tongue tho 10/10 https://t.co/VFKG1vxGjB	NaN	https://twitter.com/dog_rates/status/666345417576210432/photo/1	10	10	None	None	114031	146	https://t.co/VFKG1vxGjB	11	0	320	2015
1885	666273097616637952	NaN	NaN	2015-11-16 15:14:19+00:00	iPhone	Can take selfies 11/10 https://t.co/ws2AMaNwPW	NaN	https://twitter.com/dog_rates/status/666273097616637952/photo/1	11	10	None	None	114031	82	https://t.co/ws2AMaNwPW	11	0	320	2015
1886	666268910803644416	NaN	NaN	2015-11-16 14:57:41+00:00	iPhone	Very concerned about fellow dog trapped in computer. 10/10 https://t.co/0yxApIikpk	NaN	https://twitter.com/dog_rates/status/666268910803644416/photo/1	10	10	None	None	114031	37	https://t.co/0yxApIikpk	11	0	320	2015
1887	666102155909144576	NaN	NaN	2015-11-16 03:55:04+00:00	iPhone	Oh my. Here you are seeing an Adobe Setter giving birth to twins!!! The world is an amazing place. 11/10 https://t.co/11LvqN4WLq	NaN	https://twitter.com/dog_rates/status/666102155909144576/photo/1	11	10	None	None	114031	16	https://t.co/11LvqN4WLq	11	0	320	2015
1888	666073100786774016	NaN	NaN	2015-11-16 01:59:36+00:00	iPhone	Let's hope this flight isn't Malaysian (lol). What a dog! Almost completely camouflaged. 10/10 I trust this pilot https://t.co/Yk6GHE9tOY	NaN	https://twitter.com/dog_rates/status/666073100786774016/photo/1	10	10	None	None	114031	174	https://t.co/Yk6GHE9tOY	11	0	320	2015
1889	666063827256086533	NaN	NaN	2015-11-16 01:22:45+00:00	iPhone	This is the happiest dog you will ever see. Very committed owner. Nice couch. 10/10 https://t.co/RhUEAloehK	NaN	https://twitter.com/dog_rates/status/666063827256086533/photo/1	10	10	None	None	114031	232	https://t.co/RhUEAloehK	11	0	320	2015
1890	666055525042405380	NaN	NaN	2015-11-16 00:49:46+00:00	iPhone	Here is a Siberian heavily armored polar bear mix. Strong owner. 10/10 I would do unspeakable things to pet this dog https://t.co/rdivxLiqEt	NaN	https://twitter.com/dog_rates/status/666055525042405380/photo/1	10	10	None	None	114031	261	https://t.co/rdivxLiqEt	11	0	320	2015
1891	666050758794694657	NaN	NaN	2015-11-16 00:30:50+00:00	iPhone	This is a truly beautiful English Wilson Staff retriever. Has a nice phone. Privileged. 10/10 would trade lives with https://t.co/fvIbQfHjIe	NaN	https://twitter.com/dog_rates/status/666050758794694657/photo/1	10	10	None	None	114031	60	https://t.co/fvIbQfHjIe	11	0	320	2015

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Symbol

Other Punctuation

Decimal Number

Space Separator

Connector Punctuation

Control

Close Punctuation

Open Punctuation

Dash Punctuation

Math Symbol

Modifier Symbol

Nonspacing Mark

Most occurring scripts

Most frequent character per script

Latin

Common

Inherited

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

None

Emoticons

Enclosed Alphanum Sup

VS

Dingbats

Misc Symbols

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Connector Punctuation

Dash Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script